Pandas Profiling Report

Dataset statistics

Number of variables	11
Number of observations	865
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	74.5 KiB
Average record size in memory	88.1 B

Variable types

DateTime	1
Numeric	10

Alerts

`Open` is highly correlated with `High` and 4 other fields	High correlation
`High` is highly correlated with `Open` and 4 other fields	High correlation
`Low` is highly correlated with `Open` and 4 other fields	High correlation
`Close` is highly correlated with `Open` and 4 other fields	High correlation
`Adj Close` is highly correlated with `Open` and 4 other fields	High correlation
`S_10` is highly correlated with `Open` and 4 other fields	High correlation
`Open-Close` is highly correlated with `Volume` and 1 other fields	High correlation
`Open-Open` is highly correlated with `Volume` and 1 other fields	High correlation
`Volume` is highly correlated with `Open-Close` and 1 other fields	High correlation
`Date` has unique values	Unique
`Corr` has unique values	Unique
`Open-Close` has 19 (2.2%) zeros	Zeros

Reproduction

Analysis started	2022-11-10 10:23:58.534832
Analysis finished	2022-11-10 10:24:08.272227
Duration	9.74 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

Date
Date

UNIQUE

Distinct	865
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.9 KiB

Minimum	2019-06-06 00:00:00
Maximum	2022-11-08 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Open
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	745
Distinct (%)	86.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.82716765

Minimum	15.96000004
Maximum	63.25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	15.96000004
5-th percentile	23.34199982
Q1	30.51000023
median	35.47000122
Q3	44.99000168
95-th percentile	56.31199951
Maximum	63.25
Range	47.28999996
Interquartile range (IQR)	14.48000145

Descriptive statistics

Standard deviation	9.908622816
Coefficient of variation (CV)	0.2619446137
Kurtosis	-0.6420970844
Mean	37.82716765
Median Absolute Deviation (MAD)	6.909999847
Skewness	0.4539407918
Sum	32720.50001
Variance	98.18080611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	5	0.6%
45	4	0.5%
31	4	0.5%
37	3	0.3%
30.39999962	3	0.3%
29.11000061	3	0.3%
41	3	0.3%
36.5	3	0.3%
32.09999847	3	0.3%
32.33000183	3	0.3%
Other values (735)	831	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15.96000004	1	0.1%
17.76000023	1	0.1%
20.14999962	1	0.1%
20.18000031	1	0.1%
20.37000084	1	0.1%
20.70000076	1	0.1%
20.93000031	1	0.1%
21	1	0.1%
21.04000092	1	0.1%
21.06999969	1	0.1%

Value	Count	Frequency (%)
63.25	1	0.1%
62	1	0.1%
61.02000046	1	0.1%
60.74000168	1	0.1%
60.34999847	1	0.1%
60.33000183	1	0.1%
60.11999893	1	0.1%
60.11000061	1	0.1%
60	3	0.3%
59.99000168	1	0.1%

High
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	782
Distinct (%)	90.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.59789251

Minimum	17.79999924
Maximum	64.05000305
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	17.79999924
5-th percentile	23.93199959
Q1	31.25
median	36.31000137
Q3	45.63999939
95-th percentile	57.60200043
Maximum	64.05000305
Range	46.25000381
Interquartile range (IQR)	14.38999939

Descriptive statistics

Standard deviation	9.975656343
Coefficient of variation (CV)	0.2584508038
Kurtosis	-0.6472829676
Mean	38.59789251
Median Absolute Deviation (MAD)	6.98000145
Skewness	0.4670898675
Sum	33387.17702
Variance	99.51371948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44.34999847	4	0.5%
44.79999924	4	0.5%
34	3	0.3%
44.24000168	3	0.3%
30.14999962	3	0.3%
49.95000076	3	0.3%
46.65999985	3	0.3%
47.68999863	3	0.3%
47.93999863	3	0.3%
35.09999847	3	0.3%
Other values (772)	833	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17.79999924	1	0.1%
20.30999947	1	0.1%
21.12599945	1	0.1%
21.26000023	1	0.1%
21.37000084	1	0.1%
21.39999962	1	0.1%
21.46500015	1	0.1%
21.48999977	1	0.1%
21.61000061	1	0.1%
21.78000069	2	0.2%

Value	Count	Frequency (%)
64.05000305	1	0.1%
63.5	1	0.1%
61.5	1	0.1%
61.31000137	1	0.1%
61.09000015	1	0.1%
61.06000137	1	0.1%
61.02000046	1	0.1%
61.00999832	1	0.1%
60.95000076	1	0.1%
60.93000031	1	0.1%

Low
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	775
Distinct (%)	89.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.96529825

Minimum	13.71000004
Maximum	60.79999924
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	13.71000004
5-th percentile	22.45800056
Q1	29.82999992
median	34.51499939
Q3	43.95000076
95-th percentile	54.97799988
Maximum	60.79999924
Range	47.0899992
Interquartile range (IQR)	14.12000084

Descriptive statistics

Standard deviation	9.767729332
Coefficient of variation (CV)	0.2642405119
Kurtosis	-0.6574173423
Mean	36.96529825
Median Absolute Deviation (MAD)	6.664999008
Skewness	0.4273275148
Sum	31974.98299
Variance	95.4085363
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55	3	0.3%
35.25999832	3	0.3%
33.54999924	3	0.3%
32.5	3	0.3%
48.52999878	3	0.3%
29.36000061	3	0.3%
43.56000137	3	0.3%
31.40999985	3	0.3%
31	3	0.3%
30.47999954	2	0.2%
Other values (765)	836	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13.71000004	1	0.1%
15.69999981	1	0.1%
18.01000023	1	0.1%
19.10000038	1	0.1%
19.72999954	1	0.1%
19.89500046	1	0.1%
20.15500069	1	0.1%
20.37000084	1	0.1%
20.43000031	1	0.1%
20.5909996	1	0.1%

Value	Count	Frequency (%)
60.79999924	1	0.1%
60.39500046	1	0.1%
59.84000015	1	0.1%
59.54999924	1	0.1%
59.54000092	1	0.1%
59.31499863	1	0.1%
59.18000031	1	0.1%
59.11999893	1	0.1%
58.95000076	1	0.1%
58.75	1	0.1%

Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	756
Distinct (%)	87.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.77294798

Minimum	14.81999969
Maximum	63.18000031
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	14.81999969
5-th percentile	23.20800056
Q1	30.45999908
median	35.22999954
Q3	44.68999863
95-th percentile	56.08800049
Maximum	63.18000031
Range	48.36000061
Interquartile range (IQR)	14.22999954

Descriptive statistics

Standard deviation	9.850326145
Coefficient of variation (CV)	0.2607772671
Kurtosis	-0.6364361054
Mean	37.77294798
Median Absolute Deviation (MAD)	6.840000153
Skewness	0.4527817066
Sum	32673.6
Variance	97.02892517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31.68000031	3	0.3%
32.68000031	3	0.3%
34.25999832	3	0.3%
33.40999985	3	0.3%
45.72000122	3	0.3%
39.70000076	3	0.3%
33.04999924	3	0.3%
21.5	3	0.3%
31.37000084	3	0.3%
27.81999969	3	0.3%
Other values (746)	835	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14.81999969	1	0.1%
18.90999985	1	0.1%
20.29000092	1	0.1%
20.45999908	1	0.1%
20.46999931	1	0.1%
20.48999977	1	0.1%
20.64999962	1	0.1%
21.09000015	1	0.1%
21.19000053	1	0.1%
21.32999992	1	0.1%

Value	Count	Frequency (%)
63.18000031	1	0.1%
60.81000137	1	0.1%
60.74000168	1	0.1%
60.70999908	1	0.1%
60.63999939	1	0.1%
60.63000107	1	0.1%
60.52000046	1	0.1%
60.34999847	2	0.2%
60.18999863	1	0.1%
59.61000061	1	0.1%

Adj Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	756
Distinct (%)	87.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.77294798

Minimum	14.81999969
Maximum	63.18000031
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	14.81999969
5-th percentile	23.20800056
Q1	30.45999908
median	35.22999954
Q3	44.68999863
95-th percentile	56.08800049
Maximum	63.18000031
Range	48.36000061
Interquartile range (IQR)	14.22999954

Descriptive statistics

Standard deviation	9.850326145
Coefficient of variation (CV)	0.2607772671
Kurtosis	-0.6364361054
Mean	37.77294798
Median Absolute Deviation (MAD)	6.840000153
Skewness	0.4527817066
Sum	32673.6
Variance	97.02892517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31.68000031	3	0.3%
32.68000031	3	0.3%
34.25999832	3	0.3%
33.40999985	3	0.3%
45.72000122	3	0.3%
39.70000076	3	0.3%
33.04999924	3	0.3%
21.5	3	0.3%
31.37000084	3	0.3%
27.81999969	3	0.3%
Other values (746)	835	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14.81999969	1	0.1%
18.90999985	1	0.1%
20.29000092	1	0.1%
20.45999908	1	0.1%
20.46999931	1	0.1%
20.48999977	1	0.1%
20.64999962	1	0.1%
21.09000015	1	0.1%
21.19000053	1	0.1%
21.32999992	1	0.1%

Value	Count	Frequency (%)
63.18000031	1	0.1%
60.81000137	1	0.1%
60.74000168	1	0.1%
60.70999908	1	0.1%
60.63999939	1	0.1%
60.63000107	1	0.1%
60.52000046	1	0.1%
60.34999847	2	0.2%
60.18999863	1	0.1%
59.61000061	1	0.1%

Volume
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	864
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25573638.73

Minimum	3380000
Maximum	130965700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	3380000
5-th percentile	7771600
Q1	15787900
median	21976800
Q3	30935900
95-th percentile	54002480
Maximum	130965700
Range	127585700
Interquartile range (IQR)	15148000

Descriptive statistics

Standard deviation	15895280.1
Coefficient of variation (CV)	0.6215494115
Kurtosis	8.297154503
Mean	25573638.73
Median Absolute Deviation (MAD)	7439500
Skewness	2.245623901
Sum	2.21211975 × 10¹⁰
Variance	2.526599295 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15570900	2	0.2%
16403700	1	0.1%
26232800	1	0.1%
14260300	1	0.1%
14230600	1	0.1%
28868800	1	0.1%
36717300	1	0.1%
30368800	1	0.1%
25374000	1	0.1%
32165000	1	0.1%
Other values (854)	854	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3380000	1	0.1%
3775700	1	0.1%
3815300	1	0.1%
4021000	1	0.1%
4078700	1	0.1%
4412000	1	0.1%
4974000	1	0.1%
4986600	1	0.1%
5110100	1	0.1%
5251600	1	0.1%

Value	Count	Frequency (%)
130965700	1	0.1%
115601800	1	0.1%
113915000	1	0.1%
112325800	1	0.1%
107926300	1	0.1%
106631700	1	0.1%
101818200	1	0.1%
95455100	1	0.1%
92468800	1	0.1%
89586000	1	0.1%

S_10
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	862
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.84440925

Minimum	21.58099995
Maximum	60.0720005
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 KiB

Quantile statistics

Minimum	21.58099995
5-th percentile	23.37700001
Q1	30.73900032
median	35.66499977
Q3	44.55400009
95-th percentile	55.9496003
Maximum	60.0720005
Range	38.49100056
Interquartile range (IQR)	13.81499977

Descriptive statistics

Standard deviation	9.683037721
Coefficient of variation (CV)	0.2558644173
Kurtosis	-0.7226258281
Mean	37.84440925
Median Absolute Deviation (MAD)	6.769999886
Skewness	0.4504223274
Sum	32735.414
Variance	93.7612195
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46.90800018	2	0.2%
43.57099991	2	0.2%
44.05500031	2	0.2%
41.69999962	1	0.1%
41.12199974	1	0.1%
40.37499962	1	0.1%
40.30199966	1	0.1%
40.23999977	1	0.1%
40.18199959	1	0.1%
40.1159996	1	0.1%
Other values (852)	852	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21.58099995	1	0.1%
21.60300007	1	0.1%
21.60799999	1	0.1%
21.66299992	1	0.1%
21.70200005	1	0.1%
21.72099991	1	0.1%
21.78099995	1	0.1%
21.82600002	1	0.1%
21.84099998	1	0.1%
21.84900017	1	0.1%

Value	Count	Frequency (%)
60.0720005	1	0.1%
60.01800041	1	0.1%
59.83000031	1	0.1%
59.74500046	1	0.1%
59.41600037	1	0.1%
59.39500008	1	0.1%
58.86999969	1	0.1%
58.84600029	1	0.1%
58.825	1	0.1%
58.61899986	1	0.1%

Corr
Real number (ℝ)

UNIQUE

Distinct	865
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3492483339

Minimum	-0.8971070279
Maximum	0.9894741578
Zeros	0
Zeros (%)	0.0%
Negative	223
Negative (%)	25.8%
Memory size	6.9 KiB

Quantile statistics

Minimum	-0.8971070279
5-th percentile	-0.5321411155
Q1	-0.01384845299
median	0.4672296735
Q3	0.7730052605
95-th percentile	0.9246571484
Maximum	0.9894741578
Range	1.886581186
Interquartile range (IQR)	0.7868537135

Descriptive statistics

Standard deviation	0.4806273313
Coefficient of variation (CV)	1.376176447
Kurtosis	-0.8199726671
Mean	0.3492483339
Median Absolute Deviation (MAD)	0.349977253
Skewness	-0.5878968539
Sum	302.0998089
Variance	0.2310026316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5038910512	1	0.1%
0.8136090979	1	0.1%
0.2631422682	1	0.1%
0.3130738241	1	0.1%
0.2520004858	1	0.1%
0.6346820442	1	0.1%
0.8011734177	1	0.1%
0.7715586406	1	0.1%
0.61425927	1	0.1%
0.4834446681	1	0.1%
Other values (855)	855	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.8971070279	1	0.1%
-0.880482173	1	0.1%
-0.8479065758	1	0.1%
-0.7963937794	1	0.1%
-0.7749648925	1	0.1%
-0.7587808369	1	0.1%
-0.7537084148	1	0.1%
-0.7444070632	1	0.1%
-0.7114156358	1	0.1%
-0.7076789493	1	0.1%

Value	Count	Frequency (%)
0.9894741578	1	0.1%
0.9865588555	1	0.1%
0.9847270844	1	0.1%
0.9839917919	1	0.1%
0.9809413079	1	0.1%
0.9792616219	1	0.1%
0.9771316593	1	0.1%
0.975417392	1	0.1%
0.9721817424	1	0.1%
0.9671383339	1	0.1%

Open-Close
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	411
Distinct (%)	47.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03391908965

Minimum	-3.409999847
Maximum	4.88999939
Zeros	19
Zeros (%)	2.2%
Negative	397
Negative (%)	45.9%
Memory size	6.9 KiB

Quantile statistics

Minimum	-3.409999847
5-th percentile	-1.101998901
Q1	-0.25
median	0.02000045776
Q3	0.3150005341
95-th percentile	1.178000641
Maximum	4.88999939
Range	8.299999237
Interquartile range (IQR)	0.5650005341

Descriptive statistics

Standard deviation	0.757412958
Coefficient of variation (CV)	22.32999074
Kurtosis	5.996444882
Mean	0.03391908965
Median Absolute Deviation (MAD)	0.2900009155
Skewness	0.3484064571
Sum	29.34001255
Variance	0.573674389
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19	2.2%
0.02000045776	14	1.6%
-0.0299987793	11	1.3%
0.1800003052	11	1.3%
0.06999969482	10	1.2%
-0.1100006104	10	1.2%
-0.02000045776	9	1.0%
-0.06999969482	9	1.0%
0.1399993896	8	0.9%
-0.09000015259	8	0.9%
Other values (401)	756	87.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3.409999847	1	0.1%
-3.180000305	1	0.1%
-2.979999542	1	0.1%
-2.790000916	1	0.1%
-2.510002136	1	0.1%
-2.470001221	1	0.1%
-2.450000763	1	0.1%
-2.420001984	1	0.1%
-2.420000076	1	0.1%
-2.300001144	1	0.1%

Value	Count	Frequency (%)
4.88999939	1	0.1%
3.88999939	1	0.1%
3.5	1	0.1%
3.13999939	1	0.1%
2.88999939	1	0.1%
2.799999237	1	0.1%
2.549999237	1	0.1%
2.440002441	1	0.1%
2.419998169	1	0.1%
2.38999939	1	0.1%

Open-Open
Real number (ℝ)

HIGH CORRELATION

Distinct	566
Distinct (%)	65.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.01768786039

Minimum	-5.479999542
Maximum	6.570000648
Zeros	5
Zeros (%)	0.6%
Negative	448
Negative (%)	51.8%
Memory size	6.9 KiB

Quantile statistics

Minimum	-5.479999542
5-th percentile	-2.198000336
Q1	-0.7350006104
median	-0.03999900818
Q3	0.7200012207
95-th percentile	2.077998352
Maximum	6.570000648
Range	12.05000019
Interquartile range (IQR)	1.455001831

Descriptive statistics

Standard deviation	1.330979613
Coefficient of variation (CV)	-75.24819758
Kurtosis	2.383784262
Mean	-0.01768786039
Median Absolute Deviation (MAD)	0.7199993134
Skewness	0.1628849725
Sum	-15.29999924
Variance	1.771506731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.5	7	0.8%
-0.5900001526	7	0.8%
-0.1599998474	7	0.8%
0.3899993896	6	0.7%
-0.75	6	0.7%
-0.7000007629	6	0.7%
-0.04999923706	5	0.6%
-0.3899993896	5	0.6%
0	5	0.6%
0.1399993896	5	0.6%
Other values (556)	806	93.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5.479999542	1	0.1%
-4.700000763	1	0.1%
-4.649999619	1	0.1%
-4.649997711	1	0.1%
-4.259998322	1	0.1%
-4.059997559	1	0.1%
-3.920000076	1	0.1%
-3.86000061	1	0.1%
-3.63999939	1	0.1%
-3.5	1	0.1%

Value	Count	Frequency (%)
6.570000648	1	0.1%
5.919998169	1	0.1%
5.38999939	1	0.1%
5.059999466	1	0.1%
4.870000839	1	0.1%
4.040000916	1	0.1%
3.820001602	1	0.1%
3.459999084	1	0.1%
3.450000763	1	0.1%
3.340000153	1	0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Date	Open	High	Low	Close	Adj Close	Volume	S_10	Corr	Open-Close	Open-Open
0	2019-06-06	45.000000	45.750000	44.279999	44.919998	44.919998	16403700	41.700000	0.503891	0.000000	2.130001
1	2019-06-07	44.919998	45.669998	44.130001	44.160000	44.160000	12654700	42.068999	0.567517	0.000000	-0.080002
2	2019-06-10	44.020000	44.590000	42.529999	42.610001	42.610001	11618700	42.179000	0.495415	-0.139999	-0.899998
3	2019-06-11	43.220001	43.650002	41.799999	42.450001	42.450001	9095000	42.329000	0.431182	0.610001	-0.799999
4	2019-06-12	42.520000	42.650002	41.709999	42.169998	42.169998	5965300	42.552000	0.328851	0.070000	-0.700001
5	2019-06-13	43.049999	44.349998	42.799999	44.310001	44.310001	10178900	43.003000	0.361911	0.880001	0.529999
6	2019-06-14	44.750000	44.799999	43.110001	43.230000	43.230000	7902200	43.285000	0.132678	0.439999	1.700001
7	2019-06-17	43.279999	44.078999	42.930000	43.779999	43.779999	6557600	43.538000	-0.138791	0.049999	-1.470001
8	2019-06-18	44.299999	44.889999	43.750000	43.860001	43.860001	7313600	43.649000	-0.277532	0.520000	1.020000
9	2019-06-19	44.459999	45.500000	43.950001	44.860001	44.860001	10331500	43.635000	0.160496	0.599998	0.160000

Last rows

	Date	Open	High	Low	Close	Adj Close	Volume	S_10	Corr	Open-Close	Open-Open
855	2022-10-26	28.170000	28.980000	27.865000	28.200001	28.200001	17315900	27.089	-0.636264	-0.190001	0.170000
856	2022-10-27	28.400000	28.760000	27.660000	27.820000	27.820000	16768600	27.371	-0.293399	0.199999	0.230000
857	2022-10-28	27.809999	27.879999	26.490000	27.500000	27.500000	27116700	27.650	-0.142812	-0.010000	-0.590000
858	2022-10-31	27.610001	27.730000	26.299999	26.570000	26.570000	37327000	27.713	-0.520966	0.110001	-0.199999
859	2022-11-01	30.070000	31.000000	29.120001	29.750000	29.750000	87994000	27.927	0.153811	3.500000	2.459999
860	2022-11-02	29.570000	30.160000	28.629999	28.809999	28.809999	37083500	28.055	0.248417	-0.180000	-0.500000
861	2022-11-03	28.030001	29.520000	27.709999	28.730000	28.730000	28033200	28.141	0.312576	-0.779999	-1.539999
862	2022-11-04	29.440001	29.725000	28.040001	28.389999	28.389999	22292400	28.178	0.340572	0.710001	1.410000
863	2022-11-07	28.705000	28.825001	27.615000	27.690001	27.690001	19204100	28.182	0.179257	0.315001	-0.735001
864	2022-11-08	27.570000	28.330000	26.820000	27.440001	27.440001	27033900	28.090	0.213816	-0.120001	-1.135000

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows